Tabela TimeTemplate

Definicja tabeli TimeTemplate

Name

TimeTemplate

Code

TimeTemplate

Comment

 


Lista kolumn tabeli TimeTemplate

Name

Code

TimeTemplateID

TimeTemplateID

Hour

Hour

DayOfWeek

DayOfWeek

WeekOfMonth

WeekOfMonth

Month

Month

DateValue

DateValue

ExactDate

ExactDate


Kolumna TimeTemplateID tabeli TimeTemplate

Definicja kolumny TimeTemplateID tabeli TimeTemplate

Name

TimeTemplateID

Code

TimeTemplateID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Hour tabeli TimeTemplate

Definicja kolumny Hour tabeli TimeTemplate

Name

Hour

Code

Hour

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DayOfWeek tabeli TimeTemplate

Definicja kolumny DayOfWeek tabeli TimeTemplate

Name

DayOfWeek

Code

DayOfWeek

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WeekOfMonth tabeli TimeTemplate

Definicja kolumny WeekOfMonth tabeli TimeTemplate

Name

WeekOfMonth

Code

WeekOfMonth

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Month tabeli TimeTemplate

Definicja kolumny Month tabeli TimeTemplate

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DateValue tabeli TimeTemplate

Definicja kolumny DateValue tabeli TimeTemplate

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExactDate tabeli TimeTemplate

Definicja kolumny ExactDate tabeli TimeTemplate

Name

ExactDate

Code

ExactDate

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli TimeTemplate

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TimeTemplate

Definicja klucza Identifier_1 tabeli TimeTemplate

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment